SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE dbo.[DnnProduct_Journal_Comment_List]
@JournalId int
AS
SELECT jc.*, u.* FROM dbo.[DnnProduct_Journal_Comments] as jc 
	INNER JOIN dbo.[DnnProduct_Users] as u ON jc.UserId = u.UserId
WHERE jc.JournalId = @JournalId
ORDER BY jc.CommentId


GO
